/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80037 (8.0.37)
 Source Host           : localhost:3306
 Source Schema         : fanjingwen

 Target Server Type    : MySQL
 Target Server Version : 80037 (8.0.37)
 File Encoding         : 65001

 Date: 21/06/2024 12:16:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Article
-- ----------------------------
DROP TABLE IF EXISTS `Article`;
CREATE TABLE `Article` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `job_category` varchar(255) NOT NULL,
  `major_category` varchar(255) NOT NULL,
  `author` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of Article
-- ----------------------------
BEGIN;
INSERT INTO `Article` (`id`, `title`, `content`, `job_category`, `major_category`, `author`) VALUES (10, 'tea-info1', '<p>tea-info1<img src=\"https://ts1.cn.mm.bing.net/th/id/R-C.9de53f9726576696b318a8d95c0946cb?rik=sWB3V9KSxHbThw&amp;riu=http%3a%2f%2fpic.bizhi360.com%2fbbpic%2f95%2f9995_1.jpg&amp;ehk=GcPUjJED69TBvg9XxQr2klzDzfRsQWhAfLKlIAUWHJQ%3d&amp;risl=&amp;pid=ImgRaw&amp;r=0\" contenteditable=\"false\" style=\"font-size: var(--font-size); max-width: 100%;\"/></p>job1、major1', 'job1', 'major1', 10);
INSERT INTO `Article` (`id`, `title`, `content`, `job_category`, `major_category`, `author`) VALUES (11, 'tea-info2', '<p><b></b>tea-info2tea-info2tea-info2<br/></p><p>job1、major2</p>', 'job1', 'major2', 10);
INSERT INTO `Article` (`id`, `title`, `content`, `job_category`, `major_category`, `author`) VALUES (12, 'tea-info3', '<p><b></b>tea-info3tea-info3tea-info3<br/></p><p>job2、major1</p>', 'job2', 'major1', 10);
INSERT INTO `Article` (`id`, `title`, `content`, `job_category`, `major_category`, `author`) VALUES (13, 'tea-info4', '<h1 id=\"1krz7\"><p>tea-info4</p><h2 id=\"rmm7z\"><p>tea-info4</p><p>job2、major2</p></h2></h1>', 'job2', 'major2', 10);
INSERT INTO `Article` (`id`, `title`, `content`, `job_category`, `major_category`, `author`) VALUES (15, 'teacher-info1', '<p>teacher-info1</p>', 'job1', 'major1', 8);
INSERT INTO `Article` (`id`, `title`, `content`, `job_category`, `major_category`, `author`) VALUES (16, 'teacher-info2', '<p>teacher-info2<br/></p>', 'job2', 'major2', 8);
INSERT INTO `Article` (`id`, `title`, `content`, `job_category`, `major_category`, `author`) VALUES (18, '新媒体运营主管', '<h4>北京-西城区&nbsp;&nbsp;|&nbsp;&nbsp;1年及以上&nbsp;&nbsp;|&nbsp;&nbsp;本科</h4><h4>五险一金补充医疗保险餐饮补贴绩效奖金年终奖金定期体检节日福利</h4><hr/><p><img src=\"https://dss2.bdstatic.com/8_V1bjqh_Q23odCf/pacific/1989826346.jpg?x=0&amp;y=0&amp;vh=150.00&amp;vw=242.00&amp;oh=150.00&amp;ow=242.00&amp;w=146&amp;h=91&amp;rs=0\" style=\"max-width:100%;\" contenteditable=\"false\"/></p><p>1、岗位职责<br/>（1）执行项目产品和服务的宣传推广：组织制定和实施项目新媒体宣传方案，挖掘项目亮点卖点，撰写宣传文案，设计制作宣传物料，组织宣传推广活动，跟踪管理各渠道宣传宣传执行，达成预期宣传绩效。<br/>（2）执行项目产品和企业整体的品牌培育：根据公司战略规划和目标市场，制定和执行品牌发展战略，推动项目品牌和企业品牌形成互相支撑和良性互动。<br/>（3）执行新媒体媒体的社群体系建维：负责新媒体社群体系开拓和维护，挖掘需求，结合公司资源提供良好解决方案。<br/>（4）完成岗位目标和上级下达的其它任务。<br/>2、任职资格<br/>（1）本科以上学历，既往业绩优秀者可放宽至大专学历。<br/>（2）专业不限。<br/>（3）熟悉各大主流平台的使用和推广流程，具备扎实的产品运营能力和数据分析能力，基于目标导向不断优化和迭代运营策略。<br/>（4）网感好，创意优，知识面丰富，思维活跃，具有较强的热点敏感度，良好的选题、统筹、沟通能力，能独立撰写方案，一定程度掌握图片处理软件。<br/>（5）1年以上新媒体运营经验者优先，接受应届毕业生。<br/></p>', 'job1', 'major1', 10);
COMMIT;

-- ----------------------------
-- Table structure for Cv
-- ----------------------------
DROP TABLE IF EXISTS `Cv`;
CREATE TABLE `Cv` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `job_prefer` varchar(255) DEFAULT NULL,
  `education_exp` varchar(255) DEFAULT NULL,
  `project_exp` varchar(255) DEFAULT NULL,
  `internship` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `other_advantage` varchar(255) DEFAULT NULL,
  `cvURL` varchar(255) DEFAULT NULL,
  `author` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of Cv
-- ----------------------------
BEGIN;
INSERT INTO `Cv` (`id`, `title`, `job_prefer`, `education_exp`, `project_exp`, `internship`, `price`, `other_advantage`, `cvURL`, `author`) VALUES (5, 'stuCV1', 'stuCV1', 'stuCV1', 'stuCV1', 'stuCV1', 'stuCV1', 'stuCV1', 'target/classes/static/222ddcd9-a176-4b66-8059-bdfedbd1bce1.pdf', 9);
INSERT INTO `Cv` (`id`, `title`, `job_prefer`, `education_exp`, `project_exp`, `internship`, `price`, `other_advantage`, `cvURL`, `author`) VALUES (6, 'stuCV2', 'stuCV2', 'stuCV2', 'stuCV2', 'stuCV2', 'stuCV2', 'stuCV2', 'target/classes/static/ee6c8591-e9ee-4125-987c-f4b16acb244e.pdf', 9);
INSERT INTO `Cv` (`id`, `title`, `job_prefer`, `education_exp`, `project_exp`, `internship`, `price`, `other_advantage`, `cvURL`, `author`) VALUES (7, 'stuCV3', 'stuCV3', 'stuCV3', 'stuCV3', 'stuCV3', 'stuCV3', 'stuCV3', 'target/classes/static/4e0dfad0-b485-4d34-bb60-c0923e491fc3.pdf', 9);
INSERT INTO `Cv` (`id`, `title`, `job_prefer`, `education_exp`, `project_exp`, `internship`, `price`, `other_advantage`, `cvURL`, `author`) VALUES (8, 'student1', 'student1', 'student1', 'student1', 'student1', 'student1', 'student1', 'target/classes/static/cd62a4ae-a25a-4192-92dd-cb4beeabf259.pdf', 7);
INSERT INTO `Cv` (`id`, `title`, `job_prefer`, `education_exp`, `project_exp`, `internship`, `price`, `other_advantage`, `cvURL`, `author`) VALUES (9, 'student2', 'student2', 'student2', 'student2', 'student2', 'student2', 'student2', 'target/classes/static/d57cd726-bbb6-41ce-9c34-e8c7d4d012b4.pdf', 7);
COMMIT;

-- ----------------------------
-- Table structure for Material
-- ----------------------------
DROP TABLE IF EXISTS `Material`;
CREATE TABLE `Material` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` varchar(10000) NOT NULL,
  `category` int NOT NULL,
  `author` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of Material
-- ----------------------------
BEGIN;
INSERT INTO `Material` (`id`, `title`, `content`, `category`, `author`) VALUES (10, 'tea-material1', '<p><b></b>tea-material1<br/></p><p>就业</p>', 1, 10);
INSERT INTO `Material` (`id`, `title`, `content`, `category`, `author`) VALUES (11, 'tea-material2', '<p>tea-material2</p><p>面试</p>', 2, 10);
INSERT INTO `Material` (`id`, `title`, `content`, `category`, `author`) VALUES (12, 'tea-material3', '<p>tea-material3</p><p>简历</p>', 3, 10);
INSERT INTO `Material` (`id`, `title`, `content`, `category`, `author`) VALUES (14, 'teacher-material1', '<p>teacher-material1</p>', 1, 8);
INSERT INTO `Material` (`id`, `title`, `content`, `category`, `author`) VALUES (15, 'teacher-material2', '<p>teacher-material2</p>', 2, 8);
INSERT INTO `Material` (`id`, `title`, `content`, `category`, `author`) VALUES (16, 'teacher-material3', '<p>teacher-material3</p>', 3, 8);
COMMIT;

-- ----------------------------
-- Table structure for PostRecord
-- ----------------------------
DROP TABLE IF EXISTS `PostRecord`;
CREATE TABLE `PostRecord` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cv_id` int NOT NULL,
  `article_id` int NOT NULL,
  `advice` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of PostRecord
-- ----------------------------
BEGIN;
INSERT INTO `PostRecord` (`id`, `cv_id`, `article_id`, `advice`) VALUES (8, 5, 10, 'aaaggg');
INSERT INTO `PostRecord` (`id`, `cv_id`, `article_id`, `advice`) VALUES (9, 9, 12, '');
INSERT INTO `PostRecord` (`id`, `cv_id`, `article_id`, `advice`) VALUES (10, 8, 15, '');
INSERT INTO `PostRecord` (`id`, `cv_id`, `article_id`, `advice`) VALUES (11, 9, 16, '');
INSERT INTO `PostRecord` (`id`, `cv_id`, `article_id`, `advice`) VALUES (12, 5, 18, 'qwer');
INSERT INTO `PostRecord` (`id`, `cv_id`, `article_id`, `advice`) VALUES (13, 6, 10, '');
INSERT INTO `PostRecord` (`id`, `cv_id`, `article_id`, `advice`) VALUES (14, 7, 10, '');
COMMIT;

-- ----------------------------
-- Table structure for User
-- ----------------------------
DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `role` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `gender` varchar(8) DEFAULT NULL,
  `introduction` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of User
-- ----------------------------
BEGIN;
INSERT INTO `User` (`id`, `username`, `password`, `role`, `gender`, `introduction`) VALUES (7, 'student', 'student', '学生', NULL, '');
INSERT INTO `User` (`id`, `username`, `password`, `role`, `gender`, `introduction`) VALUES (8, 'teacher', 'teacher', '教师', NULL, '');
INSERT INTO `User` (`id`, `username`, `password`, `role`, `gender`, `introduction`) VALUES (9, 'stu', 'stu', '学生', NULL, '');
INSERT INTO `User` (`id`, `username`, `password`, `role`, `gender`, `introduction`) VALUES (10, 'tea', 'tea', '教师', NULL, '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
